/*
 Navicat Premium Data Transfer

 Source Server         : jm
 Source Server Type    : MySQL
 Source Server Version : 80023
 Source Host           : localhost:3306
 Source Schema         : nulldemo

 Target Server Type    : MySQL
 Target Server Version : 80023
 File Encoding         : 65001

 Date: 02/04/2024 15:25:04
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for lishihui_system_user
-- ----------------------------
DROP TABLE IF EXISTS `lishihui_system_user`;
CREATE TABLE `lishihui_system_user` (
  `id` int NOT NULL AUTO_INCREMENT,
  `name` varchar(255) DEFAULT NULL,
  `password` varchar(255) DEFAULT NULL COMMENT '密码',
  `sex` varchar(255) DEFAULT NULL,
  `age` int DEFAULT NULL,
  `phone` varchar(255) DEFAULT NULL,
  `address` varchar(255) DEFAULT NULL,
  `birthday` date DEFAULT NULL,
  `email` varchar(255) DEFAULT NULL COMMENT '邮箱',
  `delstatus` int DEFAULT '0',
  `create_time` datetime DEFAULT NULL COMMENT '创建时间',
  `update_time` datetime DEFAULT NULL COMMENT '修改时间',
  `version` int DEFAULT '1' COMMENT '乐观锁',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=72 DEFAULT CHARSET=utf8 COMMENT='逻辑删去-默认是0，逻辑删去后标为1';

-- ----------------------------
-- Records of lishihui_system_user
-- ----------------------------
BEGIN;
INSERT INTO `lishihui_system_user` VALUES (1, '小李', '124', '女', 10, '1111113', '丽江', NULL, NULL, 0, NULL, NULL, 1);
INSERT INTO `lishihui_system_user` VALUES (2, 't', '123', '5', 21, '不要修改t用户', '不要修改t用户', NULL, NULL, 0, NULL, NULL, 1);
INSERT INTO `lishihui_system_user` VALUES (4, '小张', '999999', '男', 10, '1851919198', '火星水星', '2020-10-16', '99@qq.com', 0, '2021-10-31 20:35:36', '2021-10-31 20:55:52', 1);
INSERT INTO `lishihui_system_user` VALUES (5, '小雪', '999999', '男', 20, '1851919198', '火星2', '2020-10-17', '99@qq.com', 1, '2021-10-31 20:35:36', '2021-10-31 20:35:36', 1);
INSERT INTO `lishihui_system_user` VALUES (6, '大李', '999999', '女', 21, '1881919879', '武汉', '2021-10-31', '99@qq.com', 0, '2021-10-31 20:40:13', '2021-10-31 20:40:13', 1);
INSERT INTO `lishihui_system_user` VALUES (22, '大李', NULL, '男', 29, '44058871', '丽江', NULL, NULL, 0, NULL, NULL, 1);
INSERT INTO `lishihui_system_user` VALUES (24, '花猫', '123', '男', 29, '17687188085', '丽江', NULL, NULL, 0, NULL, NULL, 1);
INSERT INTO `lishihui_system_user` VALUES (26, '天蓬', '999999', '1111', 50, '1111', '111', NULL, NULL, 0, NULL, NULL, 1);
INSERT INTO `lishihui_system_user` VALUES (29, '1111', NULL, 'nan', 18, '', 'xx', NULL, NULL, 0, NULL, NULL, 1);
INSERT INTO `lishihui_system_user` VALUES (30, 'ka', NULL, '1', 15, '2456', '3', NULL, NULL, 0, NULL, NULL, 1);
INSERT INTO `lishihui_system_user` VALUES (32, 'admins', NULL, '女', 18, '12', '硅谷', NULL, NULL, 0, NULL, NULL, 1);
INSERT INTO `lishihui_system_user` VALUES (33, '宝玉', '123456', '男', 22, '4521', NULL, NULL, NULL, 0, NULL, NULL, 1);
INSERT INTO `lishihui_system_user` VALUES (35, '', NULL, '666', 26, '', '', NULL, NULL, 0, NULL, NULL, 1);
INSERT INTO `lishihui_system_user` VALUES (37, '', NULL, '女', 18, '', '沈阳大街', NULL, NULL, 0, NULL, NULL, 1);
INSERT INTO `lishihui_system_user` VALUES (38, '日光', NULL, '男', 21, '', '地球核心', NULL, NULL, 0, NULL, NULL, 1);
INSERT INTO `lishihui_system_user` VALUES (66, '小歪', NULL, '女', 21, '', '月球', NULL, NULL, 0, NULL, NULL, 1);
INSERT INTO `lishihui_system_user` VALUES (67, '小花猫', '333', NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, NULL, 1);
INSERT INTO `lishihui_system_user` VALUES (68, '大花猫', NULL, '男', 19, '123', '123', NULL, NULL, 0, NULL, NULL, 1);
INSERT INTO `lishihui_system_user` VALUES (70, 'tt1', NULL, '女', 78, '44058871', '丽江', NULL, NULL, 0, NULL, NULL, 1);
INSERT INTO `lishihui_system_user` VALUES (71, '张俊杰', '123', '男', 12, '15812341234', '中国', NULL, NULL, 0, NULL, NULL, 1);
COMMIT;

-- ----------------------------
-- Table structure for project_group_basic_info
-- ----------------------------
DROP TABLE IF EXISTS `project_group_basic_info`;
CREATE TABLE `project_group_basic_info` (
  `id` int NOT NULL AUTO_INCREMENT,
  `group_number` int DEFAULT NULL COMMENT '分组号',
  `project_id` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项目id',
  `leader_name` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '组长',
  `student_id` int DEFAULT NULL COMMENT '学生id',
  `class_grade` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '年级',
  `class_name` varchar(8) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '班级',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='项目组基本信息和分数';

-- ----------------------------
-- Records of project_group_basic_info
-- ----------------------------
BEGIN;
INSERT INTO `project_group_basic_info` VALUES (1, 0, '1', '灰灰老师', 1, '2021级', '软件工程4班');
INSERT INTO `project_group_basic_info` VALUES (2, 4, '2', '陈应仙', 2, '2021级', '软件工程4班');
COMMIT;

-- ----------------------------
-- Table structure for project_info
-- ----------------------------
DROP TABLE IF EXISTS `project_info`;
CREATE TABLE `project_info` (
  `id` int NOT NULL AUTO_INCREMENT,
  `project_name` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项目名字',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='项目基本信息';

-- ----------------------------
-- Records of project_info
-- ----------------------------
BEGIN;
INSERT INTO `project_info` VALUES (1, '软件工程设计');
INSERT INTO `project_info` VALUES (2, '美食团购商城');
COMMIT;

-- ----------------------------
-- Table structure for project_task
-- ----------------------------
DROP TABLE IF EXISTS `project_task`;
CREATE TABLE `project_task` (
  `id` int NOT NULL AUTO_INCREMENT,
  `stu_id` int DEFAULT NULL,
  `project_id` int DEFAULT NULL COMMENT '项目ID',
  `project_task` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '项目任务',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='项目任务';

-- ----------------------------
-- Records of project_task
-- ----------------------------
BEGIN;
INSERT INTO `project_task` VALUES (1, 1, 1, '软件工程设计');
INSERT INTO `project_task` VALUES (2, 2, 2, '登录');
INSERT INTO `project_task` VALUES (3, 2, 2, '退货管理');
COMMIT;

-- ----------------------------
-- Table structure for score
-- ----------------------------
DROP TABLE IF EXISTS `score`;
CREATE TABLE `score` (
  `id` int NOT NULL AUTO_INCREMENT,
  `score_type` varchar(10) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '分数类型',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='分数';

-- ----------------------------
-- Records of score
-- ----------------------------
BEGIN;
INSERT INTO `score` VALUES (1, '实验报告');
INSERT INTO `score` VALUES (2, '软件工程设计');
COMMIT;

-- ----------------------------
-- Table structure for student_and_score
-- ----------------------------
DROP TABLE IF EXISTS `student_and_score`;
CREATE TABLE `student_and_score` (
  `id` int NOT NULL AUTO_INCREMENT,
  `stu_id` int DEFAULT NULL COMMENT '学生id',
  `score_id` int DEFAULT NULL COMMENT '分数id',
  `score` double DEFAULT NULL,
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=5 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='学生和分数关系';

-- ----------------------------
-- Records of student_and_score
-- ----------------------------
BEGIN;
INSERT INTO `student_and_score` VALUES (1, 1, 1, 10);
INSERT INTO `student_and_score` VALUES (2, 1, 2, 20);
INSERT INTO `student_and_score` VALUES (3, 2, 1, 30);
INSERT INTO `student_and_score` VALUES (4, 2, 2, 40);
COMMIT;

-- ----------------------------
-- Table structure for student_info
-- ----------------------------
DROP TABLE IF EXISTS `student_info`;
CREATE TABLE `student_info` (
  `id` int NOT NULL AUTO_INCREMENT,
  `stu_number` int DEFAULT NULL COMMENT '学生序号',
  `stu_name` varchar(5) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '学生姓名',
  `project_url` varchar(255) DEFAULT NULL COMMENT '项目URL',
  `stu_id_number` varchar(11) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '学生学号',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci COMMENT='学生信息';

-- ----------------------------
-- Records of student_info
-- ----------------------------
BEGIN;
INSERT INTO `student_info` VALUES (1, 14, '李天建', 'http://litianjian.xyz:888', '20212201340');
INSERT INTO `student_info` VALUES (2, 19, '杨杨', 'http://8.137.124.53:8086', '20212201367');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
